How to set up and print labels

You can print labels from the Customers, Suppliers, and Stock modules onto your label stationery.

You can:

• Check and amend the document settings so the label text fits the stationery.

• Change the text that appears on the labels.

Watch a video

Set up labels in Report Designer (video)

How to locate your labels

Line up labels with label stationery

Some label sizes are already available in Report Designer. If you're using one of these, you can choose the label size you require. If your label size is not available, you'll need to set up a custom one to fit the labels you're using.

Check the paper size and orientation

Open: File > Page Setup.

1. Check the paper size.

2. Choose whether you're labels are Portrait or Landscape.

Use a preset label size

Open: Format > Labels and Forms

1. Select your Preset label size from the drop-down list.

   If you're not sure, check your label dimensions

   Laser label dimensions

   Preset Label Size	No Across	No Down	Dimensions mm	Dimensions Inches
   Sag0661	3	7	70 x 38.1	2.75 x 1.5
   L7160 Address	3	7	63.5 x 38.1	2.5 x 1.5
   L7161 Address	3	6	63.5 x 46.5	2.5 x 1.8
   L7162 Address	2	8	99 x 33.8	3.9 x 1.33
   L7163 Address	2	7	99 x 38.1	3.9 x 1.5
   L7164 Address	3	4	63.5 x 71.9	2.5 x 2.8
   L7165 Parcel	2	4	99 x 67.7	3.9 x 2.6
   L7166 Parcel	2	3	99 x 93.1	3.9 x 3.6
   L7167 Shipping	1	1	199.5 x 289	7.85 x 11.37
   L7168 Shipping	1	2	199.5 x 143.5	7.85 x 5.65
   L7551 Clear Address	5	13	38.1 x 21	1.5 x 0.83
   L7562 Clear Address	2	8	99 x 33.8	3.9 x 1.33
   L7563 Clear Address	2	7	99 x 38.1	3.9 x 1.5
   L7565 Clear Address	2	4	99 x 67.7	3.9 x 2.66
   L7651 Mini Address	5	13	38.1 x 21.1	1.5 x 0.83
   L7654 Video Tape Face	2	6	76.2 x 46.5	3 x 1.83
   L7654 Video Tape Spline	1	16	144.7 x 16.9	5.7 x 0.66
   L7655 Audio Cassette	2	6	88.9 x 41.9	3.5 x 1.65
   L7656 35 mm Slide	4	21	45.9 x 11.1	1.81 x 0.44
   L7663 5.25 Inch Diskette	1	8	119.3 x 33.7	4.7 x 1.32
   L7664 3.5 Inch Diskette	2	4	69.9 x 71.9	2.75 x 2.83
   L7701 Lever Arch	1	4	192 x 61.9	7.55 x 2.43
   L7702 Lever Arch	1	7	192 x 39.1	7.55 x 1.54

   Dot matrix label dimensions

   Preset label size	No across	No down	Dimensions mm	Dimensions inches
   Sage	3	8	66 x 36	2.6 x 1.41
   EAL 04 Address	1	1	88.9 x 37	3.5 x 1.45
   FAB 03 Name Tag	1	1	69 x 36	2.71 x 1.42
   OML 099 Diskette	1	1	69.9 x 48.9	2.75 x 1.92
   OML 101 Diskette	1	1	102 x 23.9	4.01 x 0.94
   OML 102 Address	1	1	102 x 37	4.01 x 1.45
   OML 103 Address	1	1	102 x 48.9	4.01 x 1.92
   OML 104 Address	1	1	127 x 37	5 x 1.45
   OML 105 Shipping	1	1	127 x 48.9	5 x 1.92
   OML 202 Address	2	1	102 x 37	4.01 x 1.45
   OML 203 Address	2	1	102 x 48.9	4.01 x 1.92

2. Click OK.

Set a custom label size

Open: Format > Labels and Forms

1. Select Custom from the Preset label size drop-down list.

2. Click Advanced.

3. Hold your label stationery landscape or portrait as required.

4. Enter the measurements:

   Tip: These default to inches. To change to mm, go to Tools > Options > Measurement.

   Number Across	Enter the number of labels across the page.
   Number down	Enter the number of labels down a page.
   Left margin	Measure the distance from the left edge of the paper to the left edge of the first label Note: If you are using dot matrix labels, the left edge is the perforation that separates the sprocket holes from the stationery.
   Top margin	Measure the distance from the top of the paper to the top of the first label.
   Width	Measure the width of a single label.
   Horizontal pitch	This is the width of the label, including any gap between labels. Measure from the left edge of the first label to the left edge of the next label across.
   Height	Measure the height of a single label.
   Vertical pitch	This is the height of the label, including any gap between labels. Measure from the top of the first label to the top of the next label down.

5. Click OK.

Change a preset label to print landscape

Make sure you've set your label size first.

Open: Format > Labels and Forms

1. Click Advanced.

2. Swap the Width and Height values. For example

   	Original value	New value
   Width	2.60	1.4174
   Height	1.4174	2.60

3. Swap the Horizontal pitch and Vertical pitch values. For example:

   	Original value	New value
   Horizontal pitch	2.6771	1.4958
   Vertical pitch	1.4958	2.6771

4. Click OK.

Change the information that appears on the label

Add text

Open: Toolbox > Add Text.

1. Click on your label where you want to enter the text.

2. Drag to make the text box the correct size.

3. Enter your text.

Add extra information from your Sage 200 data

Open: Variables pane (View > Variables)

1. Find the table and field you want to add.

2. Drag the required variable into the relevant position on the layout.

Add an image / logo

Open: Toolbox > Add Image / Logo.

1. Click on your label where you want to add the image.

2. Select Browse my PC or network for an image and click OK.

3. Browse to the image file and click Open.

Change the font, text size, colour etc

1. Select an item or to select everything on the label click Edit > Select All.

2. Open the Properties pane (View > Properties).

3. Select Text Style and click the ... button ().

4. Set the required style.

Draw boxes

Open: Toolbox > Draw Box.

1. Click on your label where you want to add the box.

2. Drag to make the box the correct size.

3. Change the border size, colour etc from the Properties pane.

Draw lines

Open: Toolbox > Draw Line.

1. Click on your label where you want to add the line.

2. Drag to make the line the correct size.

3. Change the border size, colour etc from the Properties pane.

Change the format for barcode labels

If you use bar codes for your stock items, you record the bar code on the stock record (Details tab) to make stock identification easier. Once recorded, you can print bar code labels for your stock items from Sage 200 (Stock Control > Reports > Catalogue > Stock Barcode Labels).

Barcode labels are printed in Code 39 format by default. You can change to different format if required.

Open: File Explorer > Default > Labels > Stock Bar Codes label

1. Select the bar code.

2. In the Properties pane, select Bar code Format and click .

3. Choose the required bar code format and click OK.

   

4. To save the label file:

   1. Go to File > Save As:

   2. Save in the Custom > Labels folder.

Where to save the new labels

When you save your customised labels, make sure to save it in a new folder. This is to make sure that the original isn't lost. You must also make sure that your have told Sage 200 which type of label file you want to use.

Save the label file

If you have more than one companyschool on your site, you can choose whether the amended labels should be used for all companiesschools, or just for a specific one.

When you generate a report or document Sage 200 first looks for the version in the Company folder, then the Custom folder, and if it does not find one it uses the 'out of the box' version.

Tell Sage 200 which label file to use

You only need to do this for customer and supplier labels, as there is only type of bar code label. In your Sage 200 application:

Open: Tools > Choose layouts

1. Select labels you have amended from the Layout drop-down list:

   1. Customer Label

   2. Supplier Label

2. Click Browse next to the filename.

3. Choose the type of label file you want to use, single or continuous.